FaYTDRecordsWork

EntityType | Independent
Logical Entity Name | FaYTDRecordsWork
Default Table Name | FaYTDRecordsWork
Logical Only | NO
Owner | dbo
Definition |
Note |

FaYTDRecordsWork Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
FaYTDRecordsWorkID |  | INTEGER | NO |
FileImported |  | CHAR(60) | YES |
RecordInd |  | CHAR(1) | YES |
Name |  | CHAR(53) | YES |
SSN |  | CHAR(11) | YES |
BatchID |  | CHAR(26) | YES |
OrigID |  | CHAR(23) | YES |
AwardAmt |  | NUMERIC(9, 2) | YES |
Status |  | CHAR(9) | YES |
PellID |  | CHAR(6) | YES |
SchoolName |  | CHAR(50) | YES |
Message |  | CHAR(30) | YES |
DateAdded |  | DATETIME | YES |
DateLstMod |  | DATETIME | YES |
UserId |  | INTEGER | YES |
ts |  | TIMESTAMP/DATE | NO |
DisbNum |  | SMALLINT | YES |
SeqNum |  | SMALLINT | YES |
prevDisbSequenceNum |  | INTEGER | YES |
PctEligUsedSchedAward |  | NUMERIC(7, 2) | YES |
PctEligUsed |  | NUMERIC(7, 2) | YES |
LifetimeEligUsed |  | NUMERIC(7, 3) | NO |

FaYTDRecordsWork Keys

Key Name | Key Type | Keys
FaYTDRecordsWork_FaYTDRecordsWorkID_U_C_IDX | PrimaryKey | FaYTDRecordsWorkID

FaYTDRecordsWork Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

FaYTDRecordsWork Check Constraints

Check Constraint Name | CheckConstraint

FaYTDRecordsWork Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaYTDRecordsWork | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaYTDRecordsWork | NO |  |  |

FaYTDRecordsWork Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaYTDRecordsWork Data Movement Rules

Name | Type | Rule Text/Value